Date & Time Functions

These functions are used for entering, manipulating and calculating dates and times

  • Family: PQL
  • Library: Spreadsheet
  • ◉ This function can be used with the Solve plug-in

    • Function List

    DATE

    ◉

    DATEDIF

    DATEVALUE

    DAY

    ◉

    DAYS

    ◉

    DAYS360

    EDATE

    ◉

    EOMONTH

    ◉

    HOUR

    ◉

    ISOWEEKNUM

    ◉

    MINUTE

    ◉

    MONTH

    ◉

    NETWORKDAYS

    ◉

    NETWORKDAYS.INTL

    NOW

    ◉

    SECOND

    ◉

    TIME

    TIMEVALUE

    TODAY

    ◉

    WEEKDAY

    ◉

    WEEKNUM

    WORKDAY

    WORKDAY.INTL

    YEAR

    ◉

    YEARFRAC

    ◉